DROP TABLE CRST_PO_ORGANIZATION_STRUCTURE;

CREATE TABLE CRST_PO_ORGANIZATION_STRUCTURE
(
  ORGANIZATION_STRUCTURE_ID      NUMBER (15) ,
BUSINESS_GROUP_ID              NUMBER (15) ,
NAME                           VARCHAR (30) ,
COMMENTS                       LONG ,
PRIMARY_STRUCTURE_FLAG         VARCHAR (30) ,
REQUEST_ID                     NUMBER (15) ,
PROGRAM_APPLICATION_ID         NUMBER (15) ,
PROGRAM_ID                     NUMBER (15) ,
PROGRAM_UPDATE_DATE            DATE ,
ATTRIBUTE_CATEGORY             VARCHAR (30) ,
ATTRIBUTE1                     VARCHAR (150) ,
ATTRIBUTE2                     VARCHAR (150) ,
ATTRIBUTE3                     VARCHAR (150) ,
ATTRIBUTE4                     VARCHAR (150) ,
ATTRIBUTE5                     VARCHAR (150) ,
ATTRIBUTE6                     VARCHAR (150) ,
ATTRIBUTE7                     VARCHAR (150) ,
ATTRIBUTE8                     VARCHAR (150) ,
ATTRIBUTE9                     VARCHAR (150) ,
ATTRIBUTE10                    VARCHAR (150) ,
ATTRIBUTE11                    VARCHAR (150) ,
ATTRIBUTE12                    VARCHAR (150) ,
ATTRIBUTE13                    VARCHAR (150) ,
ATTRIBUTE14                    VARCHAR (150) ,
ATTRIBUTE15                    VARCHAR (150) ,
ATTRIBUTE16                    VARCHAR (150) ,
ATTRIBUTE17                    VARCHAR (150) ,
ATTRIBUTE18                    VARCHAR (150) ,
ATTRIBUTE19                    VARCHAR (150) ,
ATTRIBUTE20                    VARCHAR (150) ,
LAST_UPDATE_DATE               DATE ,
LAST_UPDATED_BY                NUMBER (15) ,
LAST_UPDATE_LOGIN              NUMBER (15) ,
CREATED_BY                     NUMBER (15) ,
CREATION_DATE                  DATE ,
POSITION_CONTROL_STRUCTURE_FLG VARCHAR (10) ,
OBJECT_VERSION_NUMBER          NUMBER (9),
 ORGANIZATION_STRUCTURE_ID_N      NUMBER (15) 
);
